package com.itic.mall.system.orders.detail.persistence.model;

import com.itic.appbase.framework.common.persistence.model.BaseExample;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class OrdersDetailExample extends BaseExample {
    /**
    
     *
     * @mbggenerated
     */
    protected String orderByClause;

    /**
    
     *
     * @mbggenerated
     */
    protected boolean distinct;

    /**
    
     *
     * @mbggenerated
     */
    protected List<Criteria> oredCriteria;

    /**
    
     *
     * @mbggenerated
     */
    public OrdersDetailExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /**
    
     *
     * @mbggenerated
     */
    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    /**
    
     *
     * @mbggenerated
     */
    public String getOrderByClause() {
        return orderByClause;
    }

    /**
    
     *
     * @mbggenerated
     */
    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    /**
    
     *
     * @mbggenerated
     */
    public boolean isDistinct() {
        return distinct;
    }

    /**
    
     *
     * @mbggenerated
     */
    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    /**
    
     *
     * @mbggenerated
     */
    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    /**
    
     *
     * @mbggenerated
     */
    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    /**
    
     *
     * @mbggenerated
     */
    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    /**
    
     *
     * @mbggenerated
     */
    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    /**
    
     *
     * @mbggenerated
     */
    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    /**
     * This class corresponds to the database table t_orders_detail
     *
     * @mbggenerated
     */
    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("ID is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("ID is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(String value) {
            addCriterion("ID =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(String value) {
            addCriterion("ID <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(String value) {
            addCriterion("ID >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(String value) {
            addCriterion("ID >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(String value) {
            addCriterion("ID <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(String value) {
            addCriterion("ID <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLike(String value) {
            addCriterion("ID like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotLike(String value) {
            addCriterion("ID not like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<String> values) {
            addCriterion("ID in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<String> values) {
            addCriterion("ID not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(String value1, String value2) {
            addCriterion("ID between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(String value1, String value2) {
            addCriterion("ID not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveIsNull() {
            addCriterion("IS_EFFECTIVE is null");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveIsNotNull() {
            addCriterion("IS_EFFECTIVE is not null");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveEqualTo(String value) {
            addCriterion("IS_EFFECTIVE =", value, "isEffective");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveNotEqualTo(String value) {
            addCriterion("IS_EFFECTIVE <>", value, "isEffective");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveGreaterThan(String value) {
            addCriterion("IS_EFFECTIVE >", value, "isEffective");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveGreaterThanOrEqualTo(String value) {
            addCriterion("IS_EFFECTIVE >=", value, "isEffective");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveLessThan(String value) {
            addCriterion("IS_EFFECTIVE <", value, "isEffective");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveLessThanOrEqualTo(String value) {
            addCriterion("IS_EFFECTIVE <=", value, "isEffective");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveLike(String value) {
            addCriterion("IS_EFFECTIVE like", value, "isEffective");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveNotLike(String value) {
            addCriterion("IS_EFFECTIVE not like", value, "isEffective");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveIn(List<String> values) {
            addCriterion("IS_EFFECTIVE in", values, "isEffective");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveNotIn(List<String> values) {
            addCriterion("IS_EFFECTIVE not in", values, "isEffective");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveBetween(String value1, String value2) {
            addCriterion("IS_EFFECTIVE between", value1, value2, "isEffective");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveNotBetween(String value1, String value2) {
            addCriterion("IS_EFFECTIVE not between", value1, value2, "isEffective");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("CREATE_TIME is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("CREATE_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("CREATE_TIME =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("CREATE_TIME <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("CREATE_TIME >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("CREATE_TIME >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("CREATE_TIME <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("CREATE_TIME <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("CREATE_TIME in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("CREATE_TIME not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("CREATE_TIME between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("CREATE_TIME not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("UPDATE_TIME is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("UPDATE_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("UPDATE_TIME =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("UPDATE_TIME <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("UPDATE_TIME >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("UPDATE_TIME >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("UPDATE_TIME <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("UPDATE_TIME <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("UPDATE_TIME in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("UPDATE_TIME not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("UPDATE_TIME between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("UPDATE_TIME not between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andOrgCodeIsNull() {
            addCriterion("ORG_CODE is null");
            return (Criteria) this;
        }

        public Criteria andOrgCodeIsNotNull() {
            addCriterion("ORG_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andOrgCodeEqualTo(String value) {
            addCriterion("ORG_CODE =", value, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeNotEqualTo(String value) {
            addCriterion("ORG_CODE <>", value, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeGreaterThan(String value) {
            addCriterion("ORG_CODE >", value, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeGreaterThanOrEqualTo(String value) {
            addCriterion("ORG_CODE >=", value, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeLessThan(String value) {
            addCriterion("ORG_CODE <", value, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeLessThanOrEqualTo(String value) {
            addCriterion("ORG_CODE <=", value, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeLike(String value) {
            addCriterion("ORG_CODE like", value, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeNotLike(String value) {
            addCriterion("ORG_CODE not like", value, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeIn(List<String> values) {
            addCriterion("ORG_CODE in", values, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeNotIn(List<String> values) {
            addCriterion("ORG_CODE not in", values, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeBetween(String value1, String value2) {
            addCriterion("ORG_CODE between", value1, value2, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeNotBetween(String value1, String value2) {
            addCriterion("ORG_CODE not between", value1, value2, "orgCode");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNull() {
            addCriterion("CREATE_USER is null");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNotNull() {
            addCriterion("CREATE_USER is not null");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualTo(String value) {
            addCriterion("CREATE_USER =", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualTo(String value) {
            addCriterion("CREATE_USER <>", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThan(String value) {
            addCriterion("CREATE_USER >", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualTo(String value) {
            addCriterion("CREATE_USER >=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThan(String value) {
            addCriterion("CREATE_USER <", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualTo(String value) {
            addCriterion("CREATE_USER <=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLike(String value) {
            addCriterion("CREATE_USER like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotLike(String value) {
            addCriterion("CREATE_USER not like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserIn(List<String> values) {
            addCriterion("CREATE_USER in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotIn(List<String> values) {
            addCriterion("CREATE_USER not in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserBetween(String value1, String value2) {
            addCriterion("CREATE_USER between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotBetween(String value1, String value2) {
            addCriterion("CREATE_USER not between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andReorderIsNull() {
            addCriterion("REORDER is null");
            return (Criteria) this;
        }

        public Criteria andReorderIsNotNull() {
            addCriterion("REORDER is not null");
            return (Criteria) this;
        }

        public Criteria andReorderEqualTo(Integer value) {
            addCriterion("REORDER =", value, "reorder");
            return (Criteria) this;
        }

        public Criteria andReorderNotEqualTo(Integer value) {
            addCriterion("REORDER <>", value, "reorder");
            return (Criteria) this;
        }

        public Criteria andReorderGreaterThan(Integer value) {
            addCriterion("REORDER >", value, "reorder");
            return (Criteria) this;
        }

        public Criteria andReorderGreaterThanOrEqualTo(Integer value) {
            addCriterion("REORDER >=", value, "reorder");
            return (Criteria) this;
        }

        public Criteria andReorderLessThan(Integer value) {
            addCriterion("REORDER <", value, "reorder");
            return (Criteria) this;
        }

        public Criteria andReorderLessThanOrEqualTo(Integer value) {
            addCriterion("REORDER <=", value, "reorder");
            return (Criteria) this;
        }

        public Criteria andReorderIn(List<Integer> values) {
            addCriterion("REORDER in", values, "reorder");
            return (Criteria) this;
        }

        public Criteria andReorderNotIn(List<Integer> values) {
            addCriterion("REORDER not in", values, "reorder");
            return (Criteria) this;
        }

        public Criteria andReorderBetween(Integer value1, Integer value2) {
            addCriterion("REORDER between", value1, value2, "reorder");
            return (Criteria) this;
        }

        public Criteria andReorderNotBetween(Integer value1, Integer value2) {
            addCriterion("REORDER not between", value1, value2, "reorder");
            return (Criteria) this;
        }

        public Criteria andNoteIsNull() {
            addCriterion("NOTE is null");
            return (Criteria) this;
        }

        public Criteria andNoteIsNotNull() {
            addCriterion("NOTE is not null");
            return (Criteria) this;
        }

        public Criteria andNoteEqualTo(String value) {
            addCriterion("NOTE =", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteNotEqualTo(String value) {
            addCriterion("NOTE <>", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteGreaterThan(String value) {
            addCriterion("NOTE >", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteGreaterThanOrEqualTo(String value) {
            addCriterion("NOTE >=", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteLessThan(String value) {
            addCriterion("NOTE <", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteLessThanOrEqualTo(String value) {
            addCriterion("NOTE <=", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteLike(String value) {
            addCriterion("NOTE like", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteNotLike(String value) {
            addCriterion("NOTE not like", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteIn(List<String> values) {
            addCriterion("NOTE in", values, "note");
            return (Criteria) this;
        }

        public Criteria andNoteNotIn(List<String> values) {
            addCriterion("NOTE not in", values, "note");
            return (Criteria) this;
        }

        public Criteria andNoteBetween(String value1, String value2) {
            addCriterion("NOTE between", value1, value2, "note");
            return (Criteria) this;
        }

        public Criteria andNoteNotBetween(String value1, String value2) {
            addCriterion("NOTE not between", value1, value2, "note");
            return (Criteria) this;
        }

        public Criteria andUserIdIsNull() {
            addCriterion("USER_ID is null");
            return (Criteria) this;
        }

        public Criteria andUserIdIsNotNull() {
            addCriterion("USER_ID is not null");
            return (Criteria) this;
        }

        public Criteria andUserIdEqualTo(String value) {
            addCriterion("USER_ID =", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotEqualTo(String value) {
            addCriterion("USER_ID <>", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThan(String value) {
            addCriterion("USER_ID >", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThanOrEqualTo(String value) {
            addCriterion("USER_ID >=", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLessThan(String value) {
            addCriterion("USER_ID <", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLessThanOrEqualTo(String value) {
            addCriterion("USER_ID <=", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLike(String value) {
            addCriterion("USER_ID like", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotLike(String value) {
            addCriterion("USER_ID not like", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdIn(List<String> values) {
            addCriterion("USER_ID in", values, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotIn(List<String> values) {
            addCriterion("USER_ID not in", values, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdBetween(String value1, String value2) {
            addCriterion("USER_ID between", value1, value2, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotBetween(String value1, String value2) {
            addCriterion("USER_ID not between", value1, value2, "userId");
            return (Criteria) this;
        }

        public Criteria andUserNickNameIsNull() {
            addCriterion("USER_NICK_NAME is null");
            return (Criteria) this;
        }

        public Criteria andUserNickNameIsNotNull() {
            addCriterion("USER_NICK_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andUserNickNameEqualTo(String value) {
            addCriterion("USER_NICK_NAME =", value, "userNickName");
            return (Criteria) this;
        }

        public Criteria andUserNickNameNotEqualTo(String value) {
            addCriterion("USER_NICK_NAME <>", value, "userNickName");
            return (Criteria) this;
        }

        public Criteria andUserNickNameGreaterThan(String value) {
            addCriterion("USER_NICK_NAME >", value, "userNickName");
            return (Criteria) this;
        }

        public Criteria andUserNickNameGreaterThanOrEqualTo(String value) {
            addCriterion("USER_NICK_NAME >=", value, "userNickName");
            return (Criteria) this;
        }

        public Criteria andUserNickNameLessThan(String value) {
            addCriterion("USER_NICK_NAME <", value, "userNickName");
            return (Criteria) this;
        }

        public Criteria andUserNickNameLessThanOrEqualTo(String value) {
            addCriterion("USER_NICK_NAME <=", value, "userNickName");
            return (Criteria) this;
        }

        public Criteria andUserNickNameLike(String value) {
            addCriterion("USER_NICK_NAME like", value, "userNickName");
            return (Criteria) this;
        }

        public Criteria andUserNickNameNotLike(String value) {
            addCriterion("USER_NICK_NAME not like", value, "userNickName");
            return (Criteria) this;
        }

        public Criteria andUserNickNameIn(List<String> values) {
            addCriterion("USER_NICK_NAME in", values, "userNickName");
            return (Criteria) this;
        }

        public Criteria andUserNickNameNotIn(List<String> values) {
            addCriterion("USER_NICK_NAME not in", values, "userNickName");
            return (Criteria) this;
        }

        public Criteria andUserNickNameBetween(String value1, String value2) {
            addCriterion("USER_NICK_NAME between", value1, value2, "userNickName");
            return (Criteria) this;
        }

        public Criteria andUserNickNameNotBetween(String value1, String value2) {
            addCriterion("USER_NICK_NAME not between", value1, value2, "userNickName");
            return (Criteria) this;
        }

        public Criteria andActualPayIsNull() {
            addCriterion("ACTUAL_PAY is null");
            return (Criteria) this;
        }

        public Criteria andActualPayIsNotNull() {
            addCriterion("ACTUAL_PAY is not null");
            return (Criteria) this;
        }

        public Criteria andActualPayEqualTo(Double value) {
            addCriterion("ACTUAL_PAY =", value, "actualPay");
            return (Criteria) this;
        }

        public Criteria andActualPayNotEqualTo(Double value) {
            addCriterion("ACTUAL_PAY <>", value, "actualPay");
            return (Criteria) this;
        }

        public Criteria andActualPayGreaterThan(Double value) {
            addCriterion("ACTUAL_PAY >", value, "actualPay");
            return (Criteria) this;
        }

        public Criteria andActualPayGreaterThanOrEqualTo(Double value) {
            addCriterion("ACTUAL_PAY >=", value, "actualPay");
            return (Criteria) this;
        }

        public Criteria andActualPayLessThan(Double value) {
            addCriterion("ACTUAL_PAY <", value, "actualPay");
            return (Criteria) this;
        }

        public Criteria andActualPayLessThanOrEqualTo(Double value) {
            addCriterion("ACTUAL_PAY <=", value, "actualPay");
            return (Criteria) this;
        }

        public Criteria andActualPayIn(List<Double> values) {
            addCriterion("ACTUAL_PAY in", values, "actualPay");
            return (Criteria) this;
        }

        public Criteria andActualPayNotIn(List<Double> values) {
            addCriterion("ACTUAL_PAY not in", values, "actualPay");
            return (Criteria) this;
        }

        public Criteria andActualPayBetween(Double value1, Double value2) {
            addCriterion("ACTUAL_PAY between", value1, value2, "actualPay");
            return (Criteria) this;
        }

        public Criteria andActualPayNotBetween(Double value1, Double value2) {
            addCriterion("ACTUAL_PAY not between", value1, value2, "actualPay");
            return (Criteria) this;
        }

        public Criteria andStartTimeIsNull() {
            addCriterion("START_TIME is null");
            return (Criteria) this;
        }

        public Criteria andStartTimeIsNotNull() {
            addCriterion("START_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andStartTimeEqualTo(Date value) {
            addCriterion("START_TIME =", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeNotEqualTo(Date value) {
            addCriterion("START_TIME <>", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeGreaterThan(Date value) {
            addCriterion("START_TIME >", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("START_TIME >=", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeLessThan(Date value) {
            addCriterion("START_TIME <", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeLessThanOrEqualTo(Date value) {
            addCriterion("START_TIME <=", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeIn(List<Date> values) {
            addCriterion("START_TIME in", values, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeNotIn(List<Date> values) {
            addCriterion("START_TIME not in", values, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeBetween(Date value1, Date value2) {
            addCriterion("START_TIME between", value1, value2, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeNotBetween(Date value1, Date value2) {
            addCriterion("START_TIME not between", value1, value2, "startTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeIsNull() {
            addCriterion("END_TIME is null");
            return (Criteria) this;
        }

        public Criteria andEndTimeIsNotNull() {
            addCriterion("END_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andEndTimeEqualTo(Date value) {
            addCriterion("END_TIME =", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeNotEqualTo(Date value) {
            addCriterion("END_TIME <>", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeGreaterThan(Date value) {
            addCriterion("END_TIME >", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("END_TIME >=", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeLessThan(Date value) {
            addCriterion("END_TIME <", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeLessThanOrEqualTo(Date value) {
            addCriterion("END_TIME <=", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeIn(List<Date> values) {
            addCriterion("END_TIME in", values, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeNotIn(List<Date> values) {
            addCriterion("END_TIME not in", values, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeBetween(Date value1, Date value2) {
            addCriterion("END_TIME between", value1, value2, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeNotBetween(Date value1, Date value2) {
            addCriterion("END_TIME not between", value1, value2, "endTime");
            return (Criteria) this;
        }

        public Criteria andStateIsNull() {
            addCriterion("STATE is null");
            return (Criteria) this;
        }

        public Criteria andStateIsNotNull() {
            addCriterion("STATE is not null");
            return (Criteria) this;
        }

        public Criteria andStateEqualTo(String value) {
            addCriterion("STATE =", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotEqualTo(String value) {
            addCriterion("STATE <>", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateGreaterThan(String value) {
            addCriterion("STATE >", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateGreaterThanOrEqualTo(String value) {
            addCriterion("STATE >=", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateLessThan(String value) {
            addCriterion("STATE <", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateLessThanOrEqualTo(String value) {
            addCriterion("STATE <=", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateLike(String value) {
            addCriterion("STATE like", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotLike(String value) {
            addCriterion("STATE not like", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateIn(List<String> values) {
            addCriterion("STATE in", values, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotIn(List<String> values) {
            addCriterion("STATE not in", values, "state");
            return (Criteria) this;
        }

        public Criteria andStateBetween(String value1, String value2) {
            addCriterion("STATE between", value1, value2, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotBetween(String value1, String value2) {
            addCriterion("STATE not between", value1, value2, "state");
            return (Criteria) this;
        }

        public Criteria andIsShowCancelIsNull() {
            addCriterion("IS_SHOW_CANCEL is null");
            return (Criteria) this;
        }

        public Criteria andIsShowCancelIsNotNull() {
            addCriterion("IS_SHOW_CANCEL is not null");
            return (Criteria) this;
        }

        public Criteria andIsShowCancelEqualTo(String value) {
            addCriterion("IS_SHOW_CANCEL =", value, "isShowCancel");
            return (Criteria) this;
        }

        public Criteria andIsShowCancelNotEqualTo(String value) {
            addCriterion("IS_SHOW_CANCEL <>", value, "isShowCancel");
            return (Criteria) this;
        }

        public Criteria andIsShowCancelGreaterThan(String value) {
            addCriterion("IS_SHOW_CANCEL >", value, "isShowCancel");
            return (Criteria) this;
        }

        public Criteria andIsShowCancelGreaterThanOrEqualTo(String value) {
            addCriterion("IS_SHOW_CANCEL >=", value, "isShowCancel");
            return (Criteria) this;
        }

        public Criteria andIsShowCancelLessThan(String value) {
            addCriterion("IS_SHOW_CANCEL <", value, "isShowCancel");
            return (Criteria) this;
        }

        public Criteria andIsShowCancelLessThanOrEqualTo(String value) {
            addCriterion("IS_SHOW_CANCEL <=", value, "isShowCancel");
            return (Criteria) this;
        }

        public Criteria andIsShowCancelLike(String value) {
            addCriterion("IS_SHOW_CANCEL like", value, "isShowCancel");
            return (Criteria) this;
        }

        public Criteria andIsShowCancelNotLike(String value) {
            addCriterion("IS_SHOW_CANCEL not like", value, "isShowCancel");
            return (Criteria) this;
        }

        public Criteria andIsShowCancelIn(List<String> values) {
            addCriterion("IS_SHOW_CANCEL in", values, "isShowCancel");
            return (Criteria) this;
        }

        public Criteria andIsShowCancelNotIn(List<String> values) {
            addCriterion("IS_SHOW_CANCEL not in", values, "isShowCancel");
            return (Criteria) this;
        }

        public Criteria andIsShowCancelBetween(String value1, String value2) {
            addCriterion("IS_SHOW_CANCEL between", value1, value2, "isShowCancel");
            return (Criteria) this;
        }

        public Criteria andIsShowCancelNotBetween(String value1, String value2) {
            addCriterion("IS_SHOW_CANCEL not between", value1, value2, "isShowCancel");
            return (Criteria) this;
        }

        public Criteria andIsShowChangeIsNull() {
            addCriterion("IS_SHOW_CHANGE is null");
            return (Criteria) this;
        }

        public Criteria andIsShowChangeIsNotNull() {
            addCriterion("IS_SHOW_CHANGE is not null");
            return (Criteria) this;
        }

        public Criteria andIsShowChangeEqualTo(String value) {
            addCriterion("IS_SHOW_CHANGE =", value, "isShowChange");
            return (Criteria) this;
        }

        public Criteria andIsShowChangeNotEqualTo(String value) {
            addCriterion("IS_SHOW_CHANGE <>", value, "isShowChange");
            return (Criteria) this;
        }

        public Criteria andIsShowChangeGreaterThan(String value) {
            addCriterion("IS_SHOW_CHANGE >", value, "isShowChange");
            return (Criteria) this;
        }

        public Criteria andIsShowChangeGreaterThanOrEqualTo(String value) {
            addCriterion("IS_SHOW_CHANGE >=", value, "isShowChange");
            return (Criteria) this;
        }

        public Criteria andIsShowChangeLessThan(String value) {
            addCriterion("IS_SHOW_CHANGE <", value, "isShowChange");
            return (Criteria) this;
        }

        public Criteria andIsShowChangeLessThanOrEqualTo(String value) {
            addCriterion("IS_SHOW_CHANGE <=", value, "isShowChange");
            return (Criteria) this;
        }

        public Criteria andIsShowChangeLike(String value) {
            addCriterion("IS_SHOW_CHANGE like", value, "isShowChange");
            return (Criteria) this;
        }

        public Criteria andIsShowChangeNotLike(String value) {
            addCriterion("IS_SHOW_CHANGE not like", value, "isShowChange");
            return (Criteria) this;
        }

        public Criteria andIsShowChangeIn(List<String> values) {
            addCriterion("IS_SHOW_CHANGE in", values, "isShowChange");
            return (Criteria) this;
        }

        public Criteria andIsShowChangeNotIn(List<String> values) {
            addCriterion("IS_SHOW_CHANGE not in", values, "isShowChange");
            return (Criteria) this;
        }

        public Criteria andIsShowChangeBetween(String value1, String value2) {
            addCriterion("IS_SHOW_CHANGE between", value1, value2, "isShowChange");
            return (Criteria) this;
        }

        public Criteria andIsShowChangeNotBetween(String value1, String value2) {
            addCriterion("IS_SHOW_CHANGE not between", value1, value2, "isShowChange");
            return (Criteria) this;
        }

        public Criteria andIsShowFixIsNull() {
            addCriterion("IS_SHOW_FIX is null");
            return (Criteria) this;
        }

        public Criteria andIsShowFixIsNotNull() {
            addCriterion("IS_SHOW_FIX is not null");
            return (Criteria) this;
        }

        public Criteria andIsShowFixEqualTo(String value) {
            addCriterion("IS_SHOW_FIX =", value, "isShowFix");
            return (Criteria) this;
        }

        public Criteria andIsShowFixNotEqualTo(String value) {
            addCriterion("IS_SHOW_FIX <>", value, "isShowFix");
            return (Criteria) this;
        }

        public Criteria andIsShowFixGreaterThan(String value) {
            addCriterion("IS_SHOW_FIX >", value, "isShowFix");
            return (Criteria) this;
        }

        public Criteria andIsShowFixGreaterThanOrEqualTo(String value) {
            addCriterion("IS_SHOW_FIX >=", value, "isShowFix");
            return (Criteria) this;
        }

        public Criteria andIsShowFixLessThan(String value) {
            addCriterion("IS_SHOW_FIX <", value, "isShowFix");
            return (Criteria) this;
        }

        public Criteria andIsShowFixLessThanOrEqualTo(String value) {
            addCriterion("IS_SHOW_FIX <=", value, "isShowFix");
            return (Criteria) this;
        }

        public Criteria andIsShowFixLike(String value) {
            addCriterion("IS_SHOW_FIX like", value, "isShowFix");
            return (Criteria) this;
        }

        public Criteria andIsShowFixNotLike(String value) {
            addCriterion("IS_SHOW_FIX not like", value, "isShowFix");
            return (Criteria) this;
        }

        public Criteria andIsShowFixIn(List<String> values) {
            addCriterion("IS_SHOW_FIX in", values, "isShowFix");
            return (Criteria) this;
        }

        public Criteria andIsShowFixNotIn(List<String> values) {
            addCriterion("IS_SHOW_FIX not in", values, "isShowFix");
            return (Criteria) this;
        }

        public Criteria andIsShowFixBetween(String value1, String value2) {
            addCriterion("IS_SHOW_FIX between", value1, value2, "isShowFix");
            return (Criteria) this;
        }

        public Criteria andIsShowFixNotBetween(String value1, String value2) {
            addCriterion("IS_SHOW_FIX not between", value1, value2, "isShowFix");
            return (Criteria) this;
        }

        public Criteria andTypeIsNull() {
            addCriterion("TYPE is null");
            return (Criteria) this;
        }

        public Criteria andTypeIsNotNull() {
            addCriterion("TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andTypeEqualTo(String value) {
            addCriterion("TYPE =", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotEqualTo(String value) {
            addCriterion("TYPE <>", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeGreaterThan(String value) {
            addCriterion("TYPE >", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeGreaterThanOrEqualTo(String value) {
            addCriterion("TYPE >=", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeLessThan(String value) {
            addCriterion("TYPE <", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeLessThanOrEqualTo(String value) {
            addCriterion("TYPE <=", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeLike(String value) {
            addCriterion("TYPE like", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotLike(String value) {
            addCriterion("TYPE not like", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeIn(List<String> values) {
            addCriterion("TYPE in", values, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotIn(List<String> values) {
            addCriterion("TYPE not in", values, "type");
            return (Criteria) this;
        }

        public Criteria andTypeBetween(String value1, String value2) {
            addCriterion("TYPE between", value1, value2, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotBetween(String value1, String value2) {
            addCriterion("TYPE not between", value1, value2, "type");
            return (Criteria) this;
        }

        public Criteria andSumAmountIsNull() {
            addCriterion("SUM_AMOUNT is null");
            return (Criteria) this;
        }

        public Criteria andSumAmountIsNotNull() {
            addCriterion("SUM_AMOUNT is not null");
            return (Criteria) this;
        }

        public Criteria andSumAmountEqualTo(Double value) {
            addCriterion("SUM_AMOUNT =", value, "sumAmount");
            return (Criteria) this;
        }

        public Criteria andSumAmountNotEqualTo(Double value) {
            addCriterion("SUM_AMOUNT <>", value, "sumAmount");
            return (Criteria) this;
        }

        public Criteria andSumAmountGreaterThan(Double value) {
            addCriterion("SUM_AMOUNT >", value, "sumAmount");
            return (Criteria) this;
        }

        public Criteria andSumAmountGreaterThanOrEqualTo(Double value) {
            addCriterion("SUM_AMOUNT >=", value, "sumAmount");
            return (Criteria) this;
        }

        public Criteria andSumAmountLessThan(Double value) {
            addCriterion("SUM_AMOUNT <", value, "sumAmount");
            return (Criteria) this;
        }

        public Criteria andSumAmountLessThanOrEqualTo(Double value) {
            addCriterion("SUM_AMOUNT <=", value, "sumAmount");
            return (Criteria) this;
        }

        public Criteria andSumAmountIn(List<Double> values) {
            addCriterion("SUM_AMOUNT in", values, "sumAmount");
            return (Criteria) this;
        }

        public Criteria andSumAmountNotIn(List<Double> values) {
            addCriterion("SUM_AMOUNT not in", values, "sumAmount");
            return (Criteria) this;
        }

        public Criteria andSumAmountBetween(Double value1, Double value2) {
            addCriterion("SUM_AMOUNT between", value1, value2, "sumAmount");
            return (Criteria) this;
        }

        public Criteria andSumAmountNotBetween(Double value1, Double value2) {
            addCriterion("SUM_AMOUNT not between", value1, value2, "sumAmount");
            return (Criteria) this;
        }

        public Criteria andPayExpireTimeIsNull() {
            addCriterion("PAY_EXPIRE_TIME is null");
            return (Criteria) this;
        }

        public Criteria andPayExpireTimeIsNotNull() {
            addCriterion("PAY_EXPIRE_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andPayExpireTimeEqualTo(Integer value) {
            addCriterion("PAY_EXPIRE_TIME =", value, "payExpireTime");
            return (Criteria) this;
        }

        public Criteria andPayExpireTimeNotEqualTo(Integer value) {
            addCriterion("PAY_EXPIRE_TIME <>", value, "payExpireTime");
            return (Criteria) this;
        }

        public Criteria andPayExpireTimeGreaterThan(Integer value) {
            addCriterion("PAY_EXPIRE_TIME >", value, "payExpireTime");
            return (Criteria) this;
        }

        public Criteria andPayExpireTimeGreaterThanOrEqualTo(Integer value) {
            addCriterion("PAY_EXPIRE_TIME >=", value, "payExpireTime");
            return (Criteria) this;
        }

        public Criteria andPayExpireTimeLessThan(Integer value) {
            addCriterion("PAY_EXPIRE_TIME <", value, "payExpireTime");
            return (Criteria) this;
        }

        public Criteria andPayExpireTimeLessThanOrEqualTo(Integer value) {
            addCriterion("PAY_EXPIRE_TIME <=", value, "payExpireTime");
            return (Criteria) this;
        }

        public Criteria andPayExpireTimeIn(List<Integer> values) {
            addCriterion("PAY_EXPIRE_TIME in", values, "payExpireTime");
            return (Criteria) this;
        }

        public Criteria andPayExpireTimeNotIn(List<Integer> values) {
            addCriterion("PAY_EXPIRE_TIME not in", values, "payExpireTime");
            return (Criteria) this;
        }

        public Criteria andPayExpireTimeBetween(Integer value1, Integer value2) {
            addCriterion("PAY_EXPIRE_TIME between", value1, value2, "payExpireTime");
            return (Criteria) this;
        }

        public Criteria andPayExpireTimeNotBetween(Integer value1, Integer value2) {
            addCriterion("PAY_EXPIRE_TIME not between", value1, value2, "payExpireTime");
            return (Criteria) this;
        }

        public Criteria andAfterSaleStateIsNull() {
            addCriterion("AFTER_SALE_STATE is null");
            return (Criteria) this;
        }

        public Criteria andAfterSaleStateIsNotNull() {
            addCriterion("AFTER_SALE_STATE is not null");
            return (Criteria) this;
        }

        public Criteria andAfterSaleStateEqualTo(String value) {
            addCriterion("AFTER_SALE_STATE =", value, "afterSaleState");
            return (Criteria) this;
        }

        public Criteria andAfterSaleStateNotEqualTo(String value) {
            addCriterion("AFTER_SALE_STATE <>", value, "afterSaleState");
            return (Criteria) this;
        }

        public Criteria andAfterSaleStateGreaterThan(String value) {
            addCriterion("AFTER_SALE_STATE >", value, "afterSaleState");
            return (Criteria) this;
        }

        public Criteria andAfterSaleStateGreaterThanOrEqualTo(String value) {
            addCriterion("AFTER_SALE_STATE >=", value, "afterSaleState");
            return (Criteria) this;
        }

        public Criteria andAfterSaleStateLessThan(String value) {
            addCriterion("AFTER_SALE_STATE <", value, "afterSaleState");
            return (Criteria) this;
        }

        public Criteria andAfterSaleStateLessThanOrEqualTo(String value) {
            addCriterion("AFTER_SALE_STATE <=", value, "afterSaleState");
            return (Criteria) this;
        }

        public Criteria andAfterSaleStateLike(String value) {
            addCriterion("AFTER_SALE_STATE like", value, "afterSaleState");
            return (Criteria) this;
        }

        public Criteria andAfterSaleStateNotLike(String value) {
            addCriterion("AFTER_SALE_STATE not like", value, "afterSaleState");
            return (Criteria) this;
        }

        public Criteria andAfterSaleStateIn(List<String> values) {
            addCriterion("AFTER_SALE_STATE in", values, "afterSaleState");
            return (Criteria) this;
        }

        public Criteria andAfterSaleStateNotIn(List<String> values) {
            addCriterion("AFTER_SALE_STATE not in", values, "afterSaleState");
            return (Criteria) this;
        }

        public Criteria andAfterSaleStateBetween(String value1, String value2) {
            addCriterion("AFTER_SALE_STATE between", value1, value2, "afterSaleState");
            return (Criteria) this;
        }

        public Criteria andAfterSaleStateNotBetween(String value1, String value2) {
            addCriterion("AFTER_SALE_STATE not between", value1, value2, "afterSaleState");
            return (Criteria) this;
        }

        public Criteria andCouponIdIsNull() {
            addCriterion("COUPON_ID is null");
            return (Criteria) this;
        }

        public Criteria andCouponIdIsNotNull() {
            addCriterion("COUPON_ID is not null");
            return (Criteria) this;
        }

        public Criteria andCouponIdEqualTo(String value) {
            addCriterion("COUPON_ID =", value, "couponId");
            return (Criteria) this;
        }

        public Criteria andCouponIdNotEqualTo(String value) {
            addCriterion("COUPON_ID <>", value, "couponId");
            return (Criteria) this;
        }

        public Criteria andCouponIdGreaterThan(String value) {
            addCriterion("COUPON_ID >", value, "couponId");
            return (Criteria) this;
        }

        public Criteria andCouponIdGreaterThanOrEqualTo(String value) {
            addCriterion("COUPON_ID >=", value, "couponId");
            return (Criteria) this;
        }

        public Criteria andCouponIdLessThan(String value) {
            addCriterion("COUPON_ID <", value, "couponId");
            return (Criteria) this;
        }

        public Criteria andCouponIdLessThanOrEqualTo(String value) {
            addCriterion("COUPON_ID <=", value, "couponId");
            return (Criteria) this;
        }

        public Criteria andCouponIdLike(String value) {
            addCriterion("COUPON_ID like", value, "couponId");
            return (Criteria) this;
        }

        public Criteria andCouponIdNotLike(String value) {
            addCriterion("COUPON_ID not like", value, "couponId");
            return (Criteria) this;
        }

        public Criteria andCouponIdIn(List<String> values) {
            addCriterion("COUPON_ID in", values, "couponId");
            return (Criteria) this;
        }

        public Criteria andCouponIdNotIn(List<String> values) {
            addCriterion("COUPON_ID not in", values, "couponId");
            return (Criteria) this;
        }

        public Criteria andCouponIdBetween(String value1, String value2) {
            addCriterion("COUPON_ID between", value1, value2, "couponId");
            return (Criteria) this;
        }

        public Criteria andCouponIdNotBetween(String value1, String value2) {
            addCriterion("COUPON_ID not between", value1, value2, "couponId");
            return (Criteria) this;
        }

        public Criteria andOrderNoIsNull() {
            addCriterion("ORDER_NO is null");
            return (Criteria) this;
        }

        public Criteria andOrderNoIsNotNull() {
            addCriterion("ORDER_NO is not null");
            return (Criteria) this;
        }

        public Criteria andOrderNoEqualTo(String value) {
            addCriterion("ORDER_NO =", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotEqualTo(String value) {
            addCriterion("ORDER_NO <>", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoGreaterThan(String value) {
            addCriterion("ORDER_NO >", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoGreaterThanOrEqualTo(String value) {
            addCriterion("ORDER_NO >=", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLessThan(String value) {
            addCriterion("ORDER_NO <", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLessThanOrEqualTo(String value) {
            addCriterion("ORDER_NO <=", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLike(String value) {
            addCriterion("ORDER_NO like", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotLike(String value) {
            addCriterion("ORDER_NO not like", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoIn(List<String> values) {
            addCriterion("ORDER_NO in", values, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotIn(List<String> values) {
            addCriterion("ORDER_NO not in", values, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoBetween(String value1, String value2) {
            addCriterion("ORDER_NO between", value1, value2, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotBetween(String value1, String value2) {
            addCriterion("ORDER_NO not between", value1, value2, "orderNo");
            return (Criteria) this;
        }

        public Criteria andAddressIdIsNull() {
            addCriterion("ADDRESS_ID is null");
            return (Criteria) this;
        }

        public Criteria andAddressIdIsNotNull() {
            addCriterion("ADDRESS_ID is not null");
            return (Criteria) this;
        }

        public Criteria andAddressIdEqualTo(String value) {
            addCriterion("ADDRESS_ID =", value, "addressId");
            return (Criteria) this;
        }

        public Criteria andAddressIdNotEqualTo(String value) {
            addCriterion("ADDRESS_ID <>", value, "addressId");
            return (Criteria) this;
        }

        public Criteria andAddressIdGreaterThan(String value) {
            addCriterion("ADDRESS_ID >", value, "addressId");
            return (Criteria) this;
        }

        public Criteria andAddressIdGreaterThanOrEqualTo(String value) {
            addCriterion("ADDRESS_ID >=", value, "addressId");
            return (Criteria) this;
        }

        public Criteria andAddressIdLessThan(String value) {
            addCriterion("ADDRESS_ID <", value, "addressId");
            return (Criteria) this;
        }

        public Criteria andAddressIdLessThanOrEqualTo(String value) {
            addCriterion("ADDRESS_ID <=", value, "addressId");
            return (Criteria) this;
        }

        public Criteria andAddressIdLike(String value) {
            addCriterion("ADDRESS_ID like", value, "addressId");
            return (Criteria) this;
        }

        public Criteria andAddressIdNotLike(String value) {
            addCriterion("ADDRESS_ID not like", value, "addressId");
            return (Criteria) this;
        }

        public Criteria andAddressIdIn(List<String> values) {
            addCriterion("ADDRESS_ID in", values, "addressId");
            return (Criteria) this;
        }

        public Criteria andAddressIdNotIn(List<String> values) {
            addCriterion("ADDRESS_ID not in", values, "addressId");
            return (Criteria) this;
        }

        public Criteria andAddressIdBetween(String value1, String value2) {
            addCriterion("ADDRESS_ID between", value1, value2, "addressId");
            return (Criteria) this;
        }

        public Criteria andAddressIdNotBetween(String value1, String value2) {
            addCriterion("ADDRESS_ID not between", value1, value2, "addressId");
            return (Criteria) this;
        }

        public Criteria andPayNoIsNull() {
            addCriterion("PAY_NO is null");
            return (Criteria) this;
        }

        public Criteria andPayNoIsNotNull() {
            addCriterion("PAY_NO is not null");
            return (Criteria) this;
        }

        public Criteria andPayNoEqualTo(String value) {
            addCriterion("PAY_NO =", value, "payNo");
            return (Criteria) this;
        }

        public Criteria andPayNoNotEqualTo(String value) {
            addCriterion("PAY_NO <>", value, "payNo");
            return (Criteria) this;
        }

        public Criteria andPayNoGreaterThan(String value) {
            addCriterion("PAY_NO >", value, "payNo");
            return (Criteria) this;
        }

        public Criteria andPayNoGreaterThanOrEqualTo(String value) {
            addCriterion("PAY_NO >=", value, "payNo");
            return (Criteria) this;
        }

        public Criteria andPayNoLessThan(String value) {
            addCriterion("PAY_NO <", value, "payNo");
            return (Criteria) this;
        }

        public Criteria andPayNoLessThanOrEqualTo(String value) {
            addCriterion("PAY_NO <=", value, "payNo");
            return (Criteria) this;
        }

        public Criteria andPayNoLike(String value) {
            addCriterion("PAY_NO like", value, "payNo");
            return (Criteria) this;
        }

        public Criteria andPayNoNotLike(String value) {
            addCriterion("PAY_NO not like", value, "payNo");
            return (Criteria) this;
        }

        public Criteria andPayNoIn(List<String> values) {
            addCriterion("PAY_NO in", values, "payNo");
            return (Criteria) this;
        }

        public Criteria andPayNoNotIn(List<String> values) {
            addCriterion("PAY_NO not in", values, "payNo");
            return (Criteria) this;
        }

        public Criteria andPayNoBetween(String value1, String value2) {
            addCriterion("PAY_NO between", value1, value2, "payNo");
            return (Criteria) this;
        }

        public Criteria andPayNoNotBetween(String value1, String value2) {
            addCriterion("PAY_NO not between", value1, value2, "payNo");
            return (Criteria) this;
        }

        public Criteria andExpressNoIsNull() {
            addCriterion("EXPRESS_NO is null");
            return (Criteria) this;
        }

        public Criteria andExpressNoIsNotNull() {
            addCriterion("EXPRESS_NO is not null");
            return (Criteria) this;
        }

        public Criteria andExpressNoEqualTo(String value) {
            addCriterion("EXPRESS_NO =", value, "expressNo");
            return (Criteria) this;
        }

        public Criteria andExpressNoNotEqualTo(String value) {
            addCriterion("EXPRESS_NO <>", value, "expressNo");
            return (Criteria) this;
        }

        public Criteria andExpressNoGreaterThan(String value) {
            addCriterion("EXPRESS_NO >", value, "expressNo");
            return (Criteria) this;
        }

        public Criteria andExpressNoGreaterThanOrEqualTo(String value) {
            addCriterion("EXPRESS_NO >=", value, "expressNo");
            return (Criteria) this;
        }

        public Criteria andExpressNoLessThan(String value) {
            addCriterion("EXPRESS_NO <", value, "expressNo");
            return (Criteria) this;
        }

        public Criteria andExpressNoLessThanOrEqualTo(String value) {
            addCriterion("EXPRESS_NO <=", value, "expressNo");
            return (Criteria) this;
        }

        public Criteria andExpressNoLike(String value) {
            addCriterion("EXPRESS_NO like", value, "expressNo");
            return (Criteria) this;
        }

        public Criteria andExpressNoNotLike(String value) {
            addCriterion("EXPRESS_NO not like", value, "expressNo");
            return (Criteria) this;
        }

        public Criteria andExpressNoIn(List<String> values) {
            addCriterion("EXPRESS_NO in", values, "expressNo");
            return (Criteria) this;
        }

        public Criteria andExpressNoNotIn(List<String> values) {
            addCriterion("EXPRESS_NO not in", values, "expressNo");
            return (Criteria) this;
        }

        public Criteria andExpressNoBetween(String value1, String value2) {
            addCriterion("EXPRESS_NO between", value1, value2, "expressNo");
            return (Criteria) this;
        }

        public Criteria andExpressNoNotBetween(String value1, String value2) {
            addCriterion("EXPRESS_NO not between", value1, value2, "expressNo");
            return (Criteria) this;
        }

        public Criteria andExpressFeeIsNull() {
            addCriterion("EXPRESS_FEE is null");
            return (Criteria) this;
        }

        public Criteria andExpressFeeIsNotNull() {
            addCriterion("EXPRESS_FEE is not null");
            return (Criteria) this;
        }

        public Criteria andExpressFeeEqualTo(Double value) {
            addCriterion("EXPRESS_FEE =", value, "expressFee");
            return (Criteria) this;
        }

        public Criteria andExpressFeeNotEqualTo(Double value) {
            addCriterion("EXPRESS_FEE <>", value, "expressFee");
            return (Criteria) this;
        }

        public Criteria andExpressFeeGreaterThan(Double value) {
            addCriterion("EXPRESS_FEE >", value, "expressFee");
            return (Criteria) this;
        }

        public Criteria andExpressFeeGreaterThanOrEqualTo(Double value) {
            addCriterion("EXPRESS_FEE >=", value, "expressFee");
            return (Criteria) this;
        }

        public Criteria andExpressFeeLessThan(Double value) {
            addCriterion("EXPRESS_FEE <", value, "expressFee");
            return (Criteria) this;
        }

        public Criteria andExpressFeeLessThanOrEqualTo(Double value) {
            addCriterion("EXPRESS_FEE <=", value, "expressFee");
            return (Criteria) this;
        }

        public Criteria andExpressFeeIn(List<Double> values) {
            addCriterion("EXPRESS_FEE in", values, "expressFee");
            return (Criteria) this;
        }

        public Criteria andExpressFeeNotIn(List<Double> values) {
            addCriterion("EXPRESS_FEE not in", values, "expressFee");
            return (Criteria) this;
        }

        public Criteria andExpressFeeBetween(Double value1, Double value2) {
            addCriterion("EXPRESS_FEE between", value1, value2, "expressFee");
            return (Criteria) this;
        }

        public Criteria andExpressFeeNotBetween(Double value1, Double value2) {
            addCriterion("EXPRESS_FEE not between", value1, value2, "expressFee");
            return (Criteria) this;
        }

        public Criteria andReceiveExpireTimeIsNull() {
            addCriterion("RECEIVE_EXPIRE_TIME is null");
            return (Criteria) this;
        }

        public Criteria andReceiveExpireTimeIsNotNull() {
            addCriterion("RECEIVE_EXPIRE_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andReceiveExpireTimeEqualTo(Integer value) {
            addCriterion("RECEIVE_EXPIRE_TIME =", value, "receiveExpireTime");
            return (Criteria) this;
        }

        public Criteria andReceiveExpireTimeNotEqualTo(Integer value) {
            addCriterion("RECEIVE_EXPIRE_TIME <>", value, "receiveExpireTime");
            return (Criteria) this;
        }

        public Criteria andReceiveExpireTimeGreaterThan(Integer value) {
            addCriterion("RECEIVE_EXPIRE_TIME >", value, "receiveExpireTime");
            return (Criteria) this;
        }

        public Criteria andReceiveExpireTimeGreaterThanOrEqualTo(Integer value) {
            addCriterion("RECEIVE_EXPIRE_TIME >=", value, "receiveExpireTime");
            return (Criteria) this;
        }

        public Criteria andReceiveExpireTimeLessThan(Integer value) {
            addCriterion("RECEIVE_EXPIRE_TIME <", value, "receiveExpireTime");
            return (Criteria) this;
        }

        public Criteria andReceiveExpireTimeLessThanOrEqualTo(Integer value) {
            addCriterion("RECEIVE_EXPIRE_TIME <=", value, "receiveExpireTime");
            return (Criteria) this;
        }

        public Criteria andReceiveExpireTimeIn(List<Integer> values) {
            addCriterion("RECEIVE_EXPIRE_TIME in", values, "receiveExpireTime");
            return (Criteria) this;
        }

        public Criteria andReceiveExpireTimeNotIn(List<Integer> values) {
            addCriterion("RECEIVE_EXPIRE_TIME not in", values, "receiveExpireTime");
            return (Criteria) this;
        }

        public Criteria andReceiveExpireTimeBetween(Integer value1, Integer value2) {
            addCriterion("RECEIVE_EXPIRE_TIME between", value1, value2, "receiveExpireTime");
            return (Criteria) this;
        }

        public Criteria andReceiveExpireTimeNotBetween(Integer value1, Integer value2) {
            addCriterion("RECEIVE_EXPIRE_TIME not between", value1, value2, "receiveExpireTime");
            return (Criteria) this;
        }

        public Criteria andYunUserIdIsNull() {
            addCriterion("YUN_USER_ID is null");
            return (Criteria) this;
        }

        public Criteria andYunUserIdIsNotNull() {
            addCriterion("YUN_USER_ID is not null");
            return (Criteria) this;
        }

        public Criteria andYunUserIdEqualTo(String value) {
            addCriterion("YUN_USER_ID =", value, "yunUserId");
            return (Criteria) this;
        }

        public Criteria andYunUserIdNotEqualTo(String value) {
            addCriterion("YUN_USER_ID <>", value, "yunUserId");
            return (Criteria) this;
        }

        public Criteria andYunUserIdGreaterThan(String value) {
            addCriterion("YUN_USER_ID >", value, "yunUserId");
            return (Criteria) this;
        }

        public Criteria andYunUserIdGreaterThanOrEqualTo(String value) {
            addCriterion("YUN_USER_ID >=", value, "yunUserId");
            return (Criteria) this;
        }

        public Criteria andYunUserIdLessThan(String value) {
            addCriterion("YUN_USER_ID <", value, "yunUserId");
            return (Criteria) this;
        }

        public Criteria andYunUserIdLessThanOrEqualTo(String value) {
            addCriterion("YUN_USER_ID <=", value, "yunUserId");
            return (Criteria) this;
        }

        public Criteria andYunUserIdLike(String value) {
            addCriterion("YUN_USER_ID like", value, "yunUserId");
            return (Criteria) this;
        }

        public Criteria andYunUserIdNotLike(String value) {
            addCriterion("YUN_USER_ID not like", value, "yunUserId");
            return (Criteria) this;
        }

        public Criteria andYunUserIdIn(List<String> values) {
            addCriterion("YUN_USER_ID in", values, "yunUserId");
            return (Criteria) this;
        }

        public Criteria andYunUserIdNotIn(List<String> values) {
            addCriterion("YUN_USER_ID not in", values, "yunUserId");
            return (Criteria) this;
        }

        public Criteria andYunUserIdBetween(String value1, String value2) {
            addCriterion("YUN_USER_ID between", value1, value2, "yunUserId");
            return (Criteria) this;
        }

        public Criteria andYunUserIdNotBetween(String value1, String value2) {
            addCriterion("YUN_USER_ID not between", value1, value2, "yunUserId");
            return (Criteria) this;
        }

        public Criteria andIsUsePointsIsNull() {
            addCriterion("IS_USE_POINTS is null");
            return (Criteria) this;
        }

        public Criteria andIsUsePointsIsNotNull() {
            addCriterion("IS_USE_POINTS is not null");
            return (Criteria) this;
        }

        public Criteria andIsUsePointsEqualTo(String value) {
            addCriterion("IS_USE_POINTS =", value, "isUsePoints");
            return (Criteria) this;
        }

        public Criteria andIsUsePointsNotEqualTo(String value) {
            addCriterion("IS_USE_POINTS <>", value, "isUsePoints");
            return (Criteria) this;
        }

        public Criteria andIsUsePointsGreaterThan(String value) {
            addCriterion("IS_USE_POINTS >", value, "isUsePoints");
            return (Criteria) this;
        }

        public Criteria andIsUsePointsGreaterThanOrEqualTo(String value) {
            addCriterion("IS_USE_POINTS >=", value, "isUsePoints");
            return (Criteria) this;
        }

        public Criteria andIsUsePointsLessThan(String value) {
            addCriterion("IS_USE_POINTS <", value, "isUsePoints");
            return (Criteria) this;
        }

        public Criteria andIsUsePointsLessThanOrEqualTo(String value) {
            addCriterion("IS_USE_POINTS <=", value, "isUsePoints");
            return (Criteria) this;
        }

        public Criteria andIsUsePointsLike(String value) {
            addCriterion("IS_USE_POINTS like", value, "isUsePoints");
            return (Criteria) this;
        }

        public Criteria andIsUsePointsNotLike(String value) {
            addCriterion("IS_USE_POINTS not like", value, "isUsePoints");
            return (Criteria) this;
        }

        public Criteria andIsUsePointsIn(List<String> values) {
            addCriterion("IS_USE_POINTS in", values, "isUsePoints");
            return (Criteria) this;
        }

        public Criteria andIsUsePointsNotIn(List<String> values) {
            addCriterion("IS_USE_POINTS not in", values, "isUsePoints");
            return (Criteria) this;
        }

        public Criteria andIsUsePointsBetween(String value1, String value2) {
            addCriterion("IS_USE_POINTS between", value1, value2, "isUsePoints");
            return (Criteria) this;
        }

        public Criteria andIsUsePointsNotBetween(String value1, String value2) {
            addCriterion("IS_USE_POINTS not between", value1, value2, "isUsePoints");
            return (Criteria) this;
        }

        public Criteria andIsDeleteIsNull() {
            addCriterion("IS_DELETE is null");
            return (Criteria) this;
        }

        public Criteria andIsDeleteIsNotNull() {
            addCriterion("IS_DELETE is not null");
            return (Criteria) this;
        }

        public Criteria andIsDeleteEqualTo(String value) {
            addCriterion("IS_DELETE =", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteNotEqualTo(String value) {
            addCriterion("IS_DELETE <>", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteGreaterThan(String value) {
            addCriterion("IS_DELETE >", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteGreaterThanOrEqualTo(String value) {
            addCriterion("IS_DELETE >=", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteLessThan(String value) {
            addCriterion("IS_DELETE <", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteLessThanOrEqualTo(String value) {
            addCriterion("IS_DELETE <=", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteLike(String value) {
            addCriterion("IS_DELETE like", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteNotLike(String value) {
            addCriterion("IS_DELETE not like", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteIn(List<String> values) {
            addCriterion("IS_DELETE in", values, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteNotIn(List<String> values) {
            addCriterion("IS_DELETE not in", values, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteBetween(String value1, String value2) {
            addCriterion("IS_DELETE between", value1, value2, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteNotBetween(String value1, String value2) {
            addCriterion("IS_DELETE not between", value1, value2, "isDelete");
            return (Criteria) this;
        }

        public Criteria andCustomNoteIsNull() {
            addCriterion("CUSTOM_NOTE is null");
            return (Criteria) this;
        }

        public Criteria andCustomNoteIsNotNull() {
            addCriterion("CUSTOM_NOTE is not null");
            return (Criteria) this;
        }

        public Criteria andCustomNoteEqualTo(String value) {
            addCriterion("CUSTOM_NOTE =", value, "customNote");
            return (Criteria) this;
        }

        public Criteria andCustomNoteNotEqualTo(String value) {
            addCriterion("CUSTOM_NOTE <>", value, "customNote");
            return (Criteria) this;
        }

        public Criteria andCustomNoteGreaterThan(String value) {
            addCriterion("CUSTOM_NOTE >", value, "customNote");
            return (Criteria) this;
        }

        public Criteria andCustomNoteGreaterThanOrEqualTo(String value) {
            addCriterion("CUSTOM_NOTE >=", value, "customNote");
            return (Criteria) this;
        }

        public Criteria andCustomNoteLessThan(String value) {
            addCriterion("CUSTOM_NOTE <", value, "customNote");
            return (Criteria) this;
        }

        public Criteria andCustomNoteLessThanOrEqualTo(String value) {
            addCriterion("CUSTOM_NOTE <=", value, "customNote");
            return (Criteria) this;
        }

        public Criteria andCustomNoteLike(String value) {
            addCriterion("CUSTOM_NOTE like", value, "customNote");
            return (Criteria) this;
        }

        public Criteria andCustomNoteNotLike(String value) {
            addCriterion("CUSTOM_NOTE not like", value, "customNote");
            return (Criteria) this;
        }

        public Criteria andCustomNoteIn(List<String> values) {
            addCriterion("CUSTOM_NOTE in", values, "customNote");
            return (Criteria) this;
        }

        public Criteria andCustomNoteNotIn(List<String> values) {
            addCriterion("CUSTOM_NOTE not in", values, "customNote");
            return (Criteria) this;
        }

        public Criteria andCustomNoteBetween(String value1, String value2) {
            addCriterion("CUSTOM_NOTE between", value1, value2, "customNote");
            return (Criteria) this;
        }

        public Criteria andCustomNoteNotBetween(String value1, String value2) {
            addCriterion("CUSTOM_NOTE not between", value1, value2, "customNote");
            return (Criteria) this;
        }

        public Criteria andScoreIsNull() {
            addCriterion("SCORE is null");
            return (Criteria) this;
        }

        public Criteria andScoreIsNotNull() {
            addCriterion("SCORE is not null");
            return (Criteria) this;
        }

        public Criteria andScoreEqualTo(Integer value) {
            addCriterion("SCORE =", value, "score");
            return (Criteria) this;
        }

        public Criteria andScoreNotEqualTo(Integer value) {
            addCriterion("SCORE <>", value, "score");
            return (Criteria) this;
        }

        public Criteria andScoreGreaterThan(Integer value) {
            addCriterion("SCORE >", value, "score");
            return (Criteria) this;
        }

        public Criteria andScoreGreaterThanOrEqualTo(Integer value) {
            addCriterion("SCORE >=", value, "score");
            return (Criteria) this;
        }

        public Criteria andScoreLessThan(Integer value) {
            addCriterion("SCORE <", value, "score");
            return (Criteria) this;
        }

        public Criteria andScoreLessThanOrEqualTo(Integer value) {
            addCriterion("SCORE <=", value, "score");
            return (Criteria) this;
        }

        public Criteria andScoreIn(List<Integer> values) {
            addCriterion("SCORE in", values, "score");
            return (Criteria) this;
        }

        public Criteria andScoreNotIn(List<Integer> values) {
            addCriterion("SCORE not in", values, "score");
            return (Criteria) this;
        }

        public Criteria andScoreBetween(Integer value1, Integer value2) {
            addCriterion("SCORE between", value1, value2, "score");
            return (Criteria) this;
        }

        public Criteria andScoreNotBetween(Integer value1, Integer value2) {
            addCriterion("SCORE not between", value1, value2, "score");
            return (Criteria) this;
        }

        public Criteria andDeducScoreIsNull() {
            addCriterion("DEDUC_SCORE is null");
            return (Criteria) this;
        }

        public Criteria andDeducScoreIsNotNull() {
            addCriterion("DEDUC_SCORE is not null");
            return (Criteria) this;
        }

        public Criteria andDeducScoreEqualTo(Double value) {
            addCriterion("DEDUC_SCORE =", value, "deducScore");
            return (Criteria) this;
        }

        public Criteria andDeducScoreNotEqualTo(Double value) {
            addCriterion("DEDUC_SCORE <>", value, "deducScore");
            return (Criteria) this;
        }

        public Criteria andDeducScoreGreaterThan(Double value) {
            addCriterion("DEDUC_SCORE >", value, "deducScore");
            return (Criteria) this;
        }

        public Criteria andDeducScoreGreaterThanOrEqualTo(Double value) {
            addCriterion("DEDUC_SCORE >=", value, "deducScore");
            return (Criteria) this;
        }

        public Criteria andDeducScoreLessThan(Double value) {
            addCriterion("DEDUC_SCORE <", value, "deducScore");
            return (Criteria) this;
        }

        public Criteria andDeducScoreLessThanOrEqualTo(Double value) {
            addCriterion("DEDUC_SCORE <=", value, "deducScore");
            return (Criteria) this;
        }

        public Criteria andDeducScoreIn(List<Double> values) {
            addCriterion("DEDUC_SCORE in", values, "deducScore");
            return (Criteria) this;
        }

        public Criteria andDeducScoreNotIn(List<Double> values) {
            addCriterion("DEDUC_SCORE not in", values, "deducScore");
            return (Criteria) this;
        }

        public Criteria andDeducScoreBetween(Double value1, Double value2) {
            addCriterion("DEDUC_SCORE between", value1, value2, "deducScore");
            return (Criteria) this;
        }

        public Criteria andDeducScoreNotBetween(Double value1, Double value2) {
            addCriterion("DEDUC_SCORE not between", value1, value2, "deducScore");
            return (Criteria) this;
        }

        public Criteria andPayTypeIsNull() {
            addCriterion("PAY_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andPayTypeIsNotNull() {
            addCriterion("PAY_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andPayTypeEqualTo(String value) {
            addCriterion("PAY_TYPE =", value, "payType");
            return (Criteria) this;
        }

        public Criteria andPayTypeNotEqualTo(String value) {
            addCriterion("PAY_TYPE <>", value, "payType");
            return (Criteria) this;
        }

        public Criteria andPayTypeGreaterThan(String value) {
            addCriterion("PAY_TYPE >", value, "payType");
            return (Criteria) this;
        }

        public Criteria andPayTypeGreaterThanOrEqualTo(String value) {
            addCriterion("PAY_TYPE >=", value, "payType");
            return (Criteria) this;
        }

        public Criteria andPayTypeLessThan(String value) {
            addCriterion("PAY_TYPE <", value, "payType");
            return (Criteria) this;
        }

        public Criteria andPayTypeLessThanOrEqualTo(String value) {
            addCriterion("PAY_TYPE <=", value, "payType");
            return (Criteria) this;
        }

        public Criteria andPayTypeLike(String value) {
            addCriterion("PAY_TYPE like", value, "payType");
            return (Criteria) this;
        }

        public Criteria andPayTypeNotLike(String value) {
            addCriterion("PAY_TYPE not like", value, "payType");
            return (Criteria) this;
        }

        public Criteria andPayTypeIn(List<String> values) {
            addCriterion("PAY_TYPE in", values, "payType");
            return (Criteria) this;
        }

        public Criteria andPayTypeNotIn(List<String> values) {
            addCriterion("PAY_TYPE not in", values, "payType");
            return (Criteria) this;
        }

        public Criteria andPayTypeBetween(String value1, String value2) {
            addCriterion("PAY_TYPE between", value1, value2, "payType");
            return (Criteria) this;
        }

        public Criteria andPayTypeNotBetween(String value1, String value2) {
            addCriterion("PAY_TYPE not between", value1, value2, "payType");
            return (Criteria) this;
        }

        public Criteria andSourceIsNull() {
            addCriterion("SOURCE is null");
            return (Criteria) this;
        }

        public Criteria andSourceIsNotNull() {
            addCriterion("SOURCE is not null");
            return (Criteria) this;
        }

        public Criteria andSourceEqualTo(String value) {
            addCriterion("SOURCE =", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotEqualTo(String value) {
            addCriterion("SOURCE <>", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceGreaterThan(String value) {
            addCriterion("SOURCE >", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceGreaterThanOrEqualTo(String value) {
            addCriterion("SOURCE >=", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceLessThan(String value) {
            addCriterion("SOURCE <", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceLessThanOrEqualTo(String value) {
            addCriterion("SOURCE <=", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceLike(String value) {
            addCriterion("SOURCE like", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotLike(String value) {
            addCriterion("SOURCE not like", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceIn(List<String> values) {
            addCriterion("SOURCE in", values, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotIn(List<String> values) {
            addCriterion("SOURCE not in", values, "source");
            return (Criteria) this;
        }

        public Criteria andSourceBetween(String value1, String value2) {
            addCriterion("SOURCE between", value1, value2, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotBetween(String value1, String value2) {
            addCriterion("SOURCE not between", value1, value2, "source");
            return (Criteria) this;
        }

        public Criteria andNoteLevelIsNull() {
            addCriterion("NOTE_LEVEL is null");
            return (Criteria) this;
        }

        public Criteria andNoteLevelIsNotNull() {
            addCriterion("NOTE_LEVEL is not null");
            return (Criteria) this;
        }

        public Criteria andNoteLevelEqualTo(String value) {
            addCriterion("NOTE_LEVEL =", value, "noteLevel");
            return (Criteria) this;
        }

        public Criteria andNoteLevelNotEqualTo(String value) {
            addCriterion("NOTE_LEVEL <>", value, "noteLevel");
            return (Criteria) this;
        }

        public Criteria andNoteLevelGreaterThan(String value) {
            addCriterion("NOTE_LEVEL >", value, "noteLevel");
            return (Criteria) this;
        }

        public Criteria andNoteLevelGreaterThanOrEqualTo(String value) {
            addCriterion("NOTE_LEVEL >=", value, "noteLevel");
            return (Criteria) this;
        }

        public Criteria andNoteLevelLessThan(String value) {
            addCriterion("NOTE_LEVEL <", value, "noteLevel");
            return (Criteria) this;
        }

        public Criteria andNoteLevelLessThanOrEqualTo(String value) {
            addCriterion("NOTE_LEVEL <=", value, "noteLevel");
            return (Criteria) this;
        }

        public Criteria andNoteLevelLike(String value) {
            addCriterion("NOTE_LEVEL like", value, "noteLevel");
            return (Criteria) this;
        }

        public Criteria andNoteLevelNotLike(String value) {
            addCriterion("NOTE_LEVEL not like", value, "noteLevel");
            return (Criteria) this;
        }

        public Criteria andNoteLevelIn(List<String> values) {
            addCriterion("NOTE_LEVEL in", values, "noteLevel");
            return (Criteria) this;
        }

        public Criteria andNoteLevelNotIn(List<String> values) {
            addCriterion("NOTE_LEVEL not in", values, "noteLevel");
            return (Criteria) this;
        }

        public Criteria andNoteLevelBetween(String value1, String value2) {
            addCriterion("NOTE_LEVEL between", value1, value2, "noteLevel");
            return (Criteria) this;
        }

        public Criteria andNoteLevelNotBetween(String value1, String value2) {
            addCriterion("NOTE_LEVEL not between", value1, value2, "noteLevel");
            return (Criteria) this;
        }

        public Criteria andCloseReasonIsNull() {
            addCriterion("CLOSE_REASON is null");
            return (Criteria) this;
        }

        public Criteria andCloseReasonIsNotNull() {
            addCriterion("CLOSE_REASON is not null");
            return (Criteria) this;
        }

        public Criteria andCloseReasonEqualTo(String value) {
            addCriterion("CLOSE_REASON =", value, "closeReason");
            return (Criteria) this;
        }

        public Criteria andCloseReasonNotEqualTo(String value) {
            addCriterion("CLOSE_REASON <>", value, "closeReason");
            return (Criteria) this;
        }

        public Criteria andCloseReasonGreaterThan(String value) {
            addCriterion("CLOSE_REASON >", value, "closeReason");
            return (Criteria) this;
        }

        public Criteria andCloseReasonGreaterThanOrEqualTo(String value) {
            addCriterion("CLOSE_REASON >=", value, "closeReason");
            return (Criteria) this;
        }

        public Criteria andCloseReasonLessThan(String value) {
            addCriterion("CLOSE_REASON <", value, "closeReason");
            return (Criteria) this;
        }

        public Criteria andCloseReasonLessThanOrEqualTo(String value) {
            addCriterion("CLOSE_REASON <=", value, "closeReason");
            return (Criteria) this;
        }

        public Criteria andCloseReasonLike(String value) {
            addCriterion("CLOSE_REASON like", value, "closeReason");
            return (Criteria) this;
        }

        public Criteria andCloseReasonNotLike(String value) {
            addCriterion("CLOSE_REASON not like", value, "closeReason");
            return (Criteria) this;
        }

        public Criteria andCloseReasonIn(List<String> values) {
            addCriterion("CLOSE_REASON in", values, "closeReason");
            return (Criteria) this;
        }

        public Criteria andCloseReasonNotIn(List<String> values) {
            addCriterion("CLOSE_REASON not in", values, "closeReason");
            return (Criteria) this;
        }

        public Criteria andCloseReasonBetween(String value1, String value2) {
            addCriterion("CLOSE_REASON between", value1, value2, "closeReason");
            return (Criteria) this;
        }

        public Criteria andCloseReasonNotBetween(String value1, String value2) {
            addCriterion("CLOSE_REASON not between", value1, value2, "closeReason");
            return (Criteria) this;
        }

        public Criteria andLivingTypeIsNull() {
            addCriterion("LIVING_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andLivingTypeIsNotNull() {
            addCriterion("LIVING_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andLivingTypeEqualTo(String value) {
            addCriterion("LIVING_TYPE =", value, "livingType");
            return (Criteria) this;
        }

        public Criteria andLivingTypeNotEqualTo(String value) {
            addCriterion("LIVING_TYPE <>", value, "livingType");
            return (Criteria) this;
        }

        public Criteria andLivingTypeGreaterThan(String value) {
            addCriterion("LIVING_TYPE >", value, "livingType");
            return (Criteria) this;
        }

        public Criteria andLivingTypeGreaterThanOrEqualTo(String value) {
            addCriterion("LIVING_TYPE >=", value, "livingType");
            return (Criteria) this;
        }

        public Criteria andLivingTypeLessThan(String value) {
            addCriterion("LIVING_TYPE <", value, "livingType");
            return (Criteria) this;
        }

        public Criteria andLivingTypeLessThanOrEqualTo(String value) {
            addCriterion("LIVING_TYPE <=", value, "livingType");
            return (Criteria) this;
        }

        public Criteria andLivingTypeLike(String value) {
            addCriterion("LIVING_TYPE like", value, "livingType");
            return (Criteria) this;
        }

        public Criteria andLivingTypeNotLike(String value) {
            addCriterion("LIVING_TYPE not like", value, "livingType");
            return (Criteria) this;
        }

        public Criteria andLivingTypeIn(List<String> values) {
            addCriterion("LIVING_TYPE in", values, "livingType");
            return (Criteria) this;
        }

        public Criteria andLivingTypeNotIn(List<String> values) {
            addCriterion("LIVING_TYPE not in", values, "livingType");
            return (Criteria) this;
        }

        public Criteria andLivingTypeBetween(String value1, String value2) {
            addCriterion("LIVING_TYPE between", value1, value2, "livingType");
            return (Criteria) this;
        }

        public Criteria andLivingTypeNotBetween(String value1, String value2) {
            addCriterion("LIVING_TYPE not between", value1, value2, "livingType");
            return (Criteria) this;
        }
    }

    /**
     * This class corresponds to the database table t_orders_detail
     *
     * @mbggenerated do_not_delete_during_merge
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    /**
     * This class corresponds to the database table t_orders_detail
     *
     * @mbggenerated
     */
    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value) {
            super();
            this.condition = condition;
            this.value = value;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.betweenValue = true;
        }
    }
}